UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'a0JhIJ/1X6+OiisMc1MQbMibRV/z2Fggitl0z2+vbdI='
WHERE
key_id = 'c6108abaa5073513c1d386b6d46b82df02db37e555f3bde3dd627f35177b1f79'
AND (
token = 'a0JhIJ/1X6+OiisMc1MQbMibRV/z2Fggitl0z2+vbdI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)