UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Ec18SLhMkgjWuWEO1NKxj0RKjqqFHLreUT+k3V167Nk='
WHERE
key_id = '3fe165195cdc9a08a128cfc324f6cc1c247a359153834254c9a81b75cdb516a1'
AND (
token = 'Ec18SLhMkgjWuWEO1NKxj0RKjqqFHLreUT+k3V167Nk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)