UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'hnOfE6LVLiJ/ZGdlTIeHcBvBY3R9npFhx/6ODwF0Nl0='
WHERE
key_id = '7d8e4459b007a3802f11f735146321d7824995af3d71224de99d683a60d13561'
AND (
token = 'hnOfE6LVLiJ/ZGdlTIeHcBvBY3R9npFhx/6ODwF0Nl0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)