UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Os71U9PngLgVGakSMuavCvz0xRDM97LWjQY+FBhhjKk='
WHERE
key_id = 'e778ca1b10168cb52ce63e8f7d0ef0f8679bc19f4552b223b9785d2f6400acd0'
AND (
token = 'Os71U9PngLgVGakSMuavCvz0xRDM97LWjQY+FBhhjKk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)