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