UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ieRgF1gvZLy336M8yZgFAjz0fXqBWVjBo3+4ycxisPk='
WHERE
key_id = 'd390d730a4e632a112bbf303653ae9a4b36fec6a3d54f8561bf857cdf56dea18'
AND (
token = 'ieRgF1gvZLy336M8yZgFAjz0fXqBWVjBo3+4ycxisPk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)