UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'bbFTJxPW4atrZPdNGYmlhphDNsvAVCzypjxxi9y/FHs='
WHERE
key_id = '78378464df1b7d7abca9614de3d06d7f701c56423437fb1d75dceb316d4d5be1'
AND (
token = 'bbFTJxPW4atrZPdNGYmlhphDNsvAVCzypjxxi9y/FHs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)