UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9AAcEzywCK+KM3cvznR/J6U1+ePuSg6Y9ViG7IkL7mo='
WHERE
key_id = '4388d67f43f67af665a172dcd07c78d2a039b116218464eda79cc1c2bd2dc312'
AND (
token = '9AAcEzywCK+KM3cvznR/J6U1+ePuSg6Y9ViG7IkL7mo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)