UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9oDW6U74Rk9R/LUQrKq/QNtBIPHWxHwzjqqvhNDk40M='
WHERE
key_id = '0e95d4d60b7598e0a1f4ec10104dad502ec324da5dcb5aed86a8b2ca72e6f536'
AND (
token = '9oDW6U74Rk9R/LUQrKq/QNtBIPHWxHwzjqqvhNDk40M='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)