UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '3yL4wSbp4iV2vF62dTH8mH8qBcnYUfdk2y3NO3aywaw='
WHERE
key_id = '11c6c57044304f58a40e0af1ad93366faacdfa0fbcb402f1c493244e6d1b9b6e'
AND (
token = '3yL4wSbp4iV2vF62dTH8mH8qBcnYUfdk2y3NO3aywaw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)