UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '0sJZN2uz5r8Hk9Q7XbC40RxcWc5ZPNRnw8Uay1sxCyo='
WHERE
key_id = '00eeadf907bc2f575b97f41687df55eae40ab585dc28bddd7f642572f4964da6'
AND (
token = '0sJZN2uz5r8Hk9Q7XbC40RxcWc5ZPNRnw8Uay1sxCyo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)