UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pYLloSEn6MO7ZZzPUKFovTSDjtXS1m4DF9hUeHjwVe4='
WHERE
key_id = 'a5a4497906c83fe94a3f661c117e3a2d93a55ad2d7c0131cb29734819796c5e3'
AND (
token = 'pYLloSEn6MO7ZZzPUKFovTSDjtXS1m4DF9hUeHjwVe4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)