UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'B48zVZDWQmSI7KEp7kz+FYMnmrmz2fyFGgIpgpx94R8='
WHERE
key_id = '4f09cb75f08bbb82c1101cd2a7254712bc13614f0ddec6a43cea9cd8dab28f2f'
AND (
token = 'B48zVZDWQmSI7KEp7kz+FYMnmrmz2fyFGgIpgpx94R8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)