UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '3VPIAMfqCJvEww6Gag5apfWl72idJuV+Wx8rhZgmQoo='
WHERE
key_id = '123faab8721d1eda951cce39a09ef194348c0ac820cc2d118e65405fe959a7f7'
AND (
token = '3VPIAMfqCJvEww6Gag5apfWl72idJuV+Wx8rhZgmQoo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)