UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '/IbJm4XN6MgsGs2lYcMZaKwYp8XfhULUF1VHl8R8/1I='
WHERE
key_id = '830b8e2ec028ee0c7b5566c5ce0d06a8afccb118a936801441de7d004df15b7e'
AND (
token = '/IbJm4XN6MgsGs2lYcMZaKwYp8XfhULUF1VHl8R8/1I='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)