UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'clW5ZWt57TrG+QDlboEjzFHo/vZJG30UmaDLV79s87o='
WHERE
key_id = 'a8526a5902050f115e858a876de4f388280fdff82084346f03b89660eeeec619'
AND (
token = 'clW5ZWt57TrG+QDlboEjzFHo/vZJG30UmaDLV79s87o='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)