UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'gRN52GDrA3VG+MB64i7QsDKptJYhBs7d2CyiNp75UW8='
WHERE
key_id = '038cdc63a1380c0287d21db450e1455c39efe417416de15cb4e688106a5623a2'
AND (
token = 'gRN52GDrA3VG+MB64i7QsDKptJYhBs7d2CyiNp75UW8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)