UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'B3NKPwyU+PfWNd5EzI8CoywO/jW3M2OCpq4gjJhCc4E='
WHERE
key_id = 'b42e249441c2637c1e47cf4de72a278a62a24329d0571f09c6ad84718b7d0c0f'
AND (
token = 'B3NKPwyU+PfWNd5EzI8CoywO/jW3M2OCpq4gjJhCc4E='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)