UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'a5c1bIoAiycXcCVsmuenDjGY95njKRhqwagv20j5Hek='
WHERE
key_id = '0940c29ab3671a2c97131fd71ca0808cd9f390ecf5494e811c6ebb4d60f33fc7'
AND (
token = 'a5c1bIoAiycXcCVsmuenDjGY95njKRhqwagv20j5Hek='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)