UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '5Bx9EOBE22SYmz94i18x5lfp4B48/BZkFgS4kchDPF4='
WHERE
key_id = '4b767fd9c3ec8d40ef4cff165c60d0c54920179db9acbf130263aeb364121899'
AND (
token = '5Bx9EOBE22SYmz94i18x5lfp4B48/BZkFgS4kchDPF4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)