UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'BTPsU087j8cJUtEiiYrxjhIw0QF9GM4/Ymk094oHC8Y='
WHERE
key_id = 'b463d646eaf95c86f12c11205a73adb91618f045e39d188745a63152b380bb1c'
AND (
token = 'BTPsU087j8cJUtEiiYrxjhIw0QF9GM4/Ymk094oHC8Y='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)