UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '50t9nzFdB0QTo+57cPrSjxxiiA8AC5b2Ixxg+L9mbCk='
WHERE
key_id = '17475af32bc0a7b75785e60c9b27d108b74b1906eac59b1314dcc37a36910f4b'
AND (
token = '50t9nzFdB0QTo+57cPrSjxxiiA8AC5b2Ixxg+L9mbCk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)