UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'iuIX58WGInjsbVXho7EWmm+RvXAOGs73nHB7FJrKXr8='
WHERE
key_id = '2a470f3eb59ea637978a9b51add6da1e28707f2d0a7bfed4936f41250a023f4b'
AND (
token = 'iuIX58WGInjsbVXho7EWmm+RvXAOGs73nHB7FJrKXr8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)