UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'VYAnLbp25/yjc/AjulRPvI5WyZq17xE+8eGnFaPdmqk='
WHERE
key_id = '583aff505b71bbd74212576b43b53584f07a903f74256804b4fd2724df5a33a3'
AND (
token = 'VYAnLbp25/yjc/AjulRPvI5WyZq17xE+8eGnFaPdmqk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)