UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '1uJC+5mzOq50r/aQRdGVBqONMAnLasIzq4Ho9th+zq0='
WHERE
key_id = '512137ceafa191145819660f3387067e2ade82de7d469b1cf9a99541e2ae2afe'
AND (
token = '1uJC+5mzOq50r/aQRdGVBqONMAnLasIzq4Ho9th+zq0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)