UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'izrRYVRm844GSD3nMCai9hzkPQcHbEM0Qfn4Gx9nop8='
WHERE
key_id = '3063899a64e32f7ecb0c9b2eb7065e6a81ea402fe08a498e41cffe0c6a646ca5'
AND (
token = 'izrRYVRm844GSD3nMCai9hzkPQcHbEM0Qfn4Gx9nop8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)