UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pdel4hpE7Z6kFpG1wLkH1ZhwmNdDdSPJeuKawR4cUX0='
WHERE
key_id = '4bac08a41c5f6f43df08424636e64749cb043313f02dab72476edd57f7083529'
AND (
token = 'pdel4hpE7Z6kFpG1wLkH1ZhwmNdDdSPJeuKawR4cUX0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)