UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pZeHEt3CTVgZ3QMKzoP7jfQLCDxVM0E3lfnR8ravX9I='
WHERE
key_id = '312b9b842991bdd1ec157703cb1b32b861e92bab8fa436d83cd7ec53d0ac7d49'
AND (
token = 'pZeHEt3CTVgZ3QMKzoP7jfQLCDxVM0E3lfnR8ravX9I='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)