UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '7L1HacmVgXDuIvbo0gRAkPijR04d5Zz+UVyFCknrygA='
WHERE
key_id = '8b25f0871e3dad063b6bb838052ac5f4a968dc242954575481eabfcc4655fb98'
AND (
token = '7L1HacmVgXDuIvbo0gRAkPijR04d5Zz+UVyFCknrygA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)