UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '/RcirvJ+059cATdiBeDN5bwAqb3gS/Ks1ouEAtA5Xfg='
WHERE
key_id = 'e4cce438a8c707981a0e4ce7140cd620858a567ae329c138157d1e0ee4196431'
AND (
token = '/RcirvJ+059cATdiBeDN5bwAqb3gS/Ks1ouEAtA5Xfg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)