UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'GuCTq+gYK6iEQ4kMCls0nj7pkEuw9w2NZbwrezcloxs='
WHERE
key_id = 'b28aabd674a82387e001f2fa4b9f8faf8dd8e54f81f567266d4097f17a56f9f2'
AND (
token = 'GuCTq+gYK6iEQ4kMCls0nj7pkEuw9w2NZbwrezcloxs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)