UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6mbSEB7JNarfuIa/jCCiaF05ku7N2e4/nHWfHLUOVZ0='
WHERE
key_id = '09d9fba6a2c25578c6694bbd3124a81bb99f28b4e8521e62c546f2adb8111fd8'
AND (
token = '6mbSEB7JNarfuIa/jCCiaF05ku7N2e4/nHWfHLUOVZ0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)